Table of contents
Invoice Forms

• Tables
  • CUSTOMERS
  • DISCOUNT
  • INVOICE
  • ITEMS
  • SHIP_TO
  • SHIPPERS
  • SOLD
  • TAX
• Queries
  • Items Sold
  • Items UnSold
  • qSubForm_Adv_Discount
  • qSubForm_Adv_Shipping
  • qSubForm_Adv_Tax
  • qSubForm_Adv_Total
  • qSubForm_SubTotal
  • qSubForm_Tax
  • qSubForm_Total
• Forms
  • 1. Invoice Unique Items
  • 2. Invoice Basic
  • 3. Invoice Intermediate
  • 4. Invoice Advanced
• Index

Sample of data stored in table ITEMS

ITEM_ID	ITEM	SKU	PRICE	TAXABLE	SHIPPING_WT	PACKAGING_FEE
0	Service 1	101ABC100	42	✖	0	0
1	Product 1	321DEF101	27,65	✔	1,1	1,25
2	Product 2	200XYZ900	3,5	✔	0,8	1
3	Service 2	101ABC101	30	✖	0	0
4	Product 3	321DEF102	20	✔	6,6	4
5	Product 4	200XYZ901	3,5	✔	0,6	0,75
6	Service 3	101ABC102	75	✖	0	0
7	Product 5	321DEF103	22,2	✔	3,65	2
8	Product 6	200XYZ902	3,55	✔	1,8	1
9	Service 4	101ABC103	99,99	✖	0	0
10	Product 7	321DEF104	28,29	✔	4,25	2,75